-
Re: Alert Someone 1 Week Before Due Date
Hi @Anthony DAmbrosio ! Not a dumb question at all. :) You could create your automation using the trigger "When a date is reached" and then in the options where it says "Run Once"…1 · -
Re: Smartsheet has been recognized as a Leader in the 2024 Gartner Magic Quadrant for Collaborative Work
I started using Smartsheet and then lots of stuff started to click! Our team has been able to expand and improve our services because we are uber-organized and leveraging the automation features. :)2 · -
Re: IF formula with multiple options
@brewhaha - Hi John! You can nest a string of IFs together. :) For example: IF([Your Column]@row="Option A", "Your Option A message", IF([Your Column]@row="Option B", &q…2 · -
Re: December Question of the Month - Join the conversation and receive a badge
So many great answers & comments in here! …I'd love to be an instant expert in history. (Like, all history - which I know a big big thing 😀) The little bits of history I've learned help to put al…6 · -
Re: Duplicate Formula
Hi @Natalie11 ! You could use the "COUNTIF" function to help identify duplicate values (in this case, names). You mentioned creating a column to "flag" duplicates - so it sounds l…1 ·